Pandas Profiling Report

Dataset statistics

Number of variables	73
Number of observations	571989
Missing cells	12954380
Missing cells (%)	31.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	314.2 MiB
Average record size in memory	576.0 B

Variable types

CAT	60
UNSUPPORTED	6
BOOL	4
DATE	3

Reproduction

Analysis started	2021-04-07 09:21:56.322903
Analysis finished	2021-04-07 09:30:32.809487
Duration	8 minutes and 36.49 seconds
Version	pandas-profiling v2.8.0
Command line	`pandas_profiling --config_file config.yaml [YOUR_FILE.csv]`
Download configuration	config.yaml

Warnings

`inactive_flag` has constant value "0"	Constant
`deleted_flag` has constant value "0"	Constant
`modify_id` has a high cardinality: 761 distinct values	High cardinality
`hco_business_id` has a high cardinality: 555511 distinct values	High cardinality
`hco_name` has a high cardinality: 443574 distinct values	High cardinality
`phone_number` has a high cardinality: 478218 distinct values	High cardinality
`formatted_name` has a high cardinality: 443574 distinct values	High cardinality
`beds` has a high cardinality: 707 distinct values	High cardinality
`jp_hco_id` has a high cardinality: 555511 distinct values	High cardinality
`jp_account_furigana` has a high cardinality: 412648 distinct values	High cardinality
`jp_hco_name` has a high cardinality: 484174 distinct values	High cardinality
`jp_hco_name_kana` has a high cardinality: 461518 distinct values	High cardinality
`jp_hco_shortname` has a high cardinality: 439543 distinct values	High cardinality
`jp_hco_shortname_kana` has a high cardinality: 412587 distinct values	High cardinality
`jp_management_small_class` has a high cardinality: 63 distinct values	High cardinality
`jp_hco_class` has a high cardinality: 89 distinct values	High cardinality
`jp_related_univ_parent` has a high cardinality: 195 distinct values	High cardinality
`jp_open_close_business_date` has a high cardinality: 175 distinct values	High cardinality
`jp_hco_rep_code` has a high cardinality: 188418 distinct values	High cardinality
`jp_hco_rep_kana` has a high cardinality: 211186 distinct values	High cardinality
`jp_hco_rep_kanji` has a high cardinality: 247490 distinct values	High cardinality
`hco_dcf_cd` has a high cardinality: 554052 distinct values	High cardinality
`jp_duplicate_hco_code` has a high cardinality: 13366 distinct values	High cardinality
`jp_permitted_beds` has a high cardinality: 728 distinct values	High cardinality
`hco_external_id` has a high cardinality: 563543 distinct values	High cardinality
`parent_hco_key` has a high cardinality: 571988 distinct values	High cardinality
`parent_hco_name` has a high cardinality: 443573 distinct values	High cardinality
`address_line_1` has a high cardinality: 60991 distinct values	High cardinality
`city` has a high cardinality: 1345 distinct values	High cardinality
`postcode` has a high cardinality: 62225 distinct values	High cardinality
`map` has a high cardinality: 62234 distinct values	High cardinality
`hco_address_source_id` has a high cardinality: 563531 distinct values	High cardinality
`address_external_id` has a high cardinality: 563531 distinct values	High cardinality
`address_phone` has a high cardinality: 478111 distinct values	High cardinality
`jp_local_area_code` has a high cardinality: 355 distinct values	High cardinality
`jp_city_code` has a high cardinality: 1368 distinct values	High cardinality
`jp_larger_section_code` has a high cardinality: 851 distinct values	High cardinality
`jp_smaller_section_code` has a high cardinality: 320 distinct values	High cardinality
`jp_address_furigana` has a high cardinality: 60751 distinct values	High cardinality
`hco_type` is highly correlated with `country_code` and 9 other fields	High correlation
`country_code` is highly correlated with `hco_type` and 13 other fields	High correlation
`jp_hco_category` is highly correlated with `country_code` and 9 other fields	High correlation
`jp_hospital_type` is highly correlated with `country_code` and 5 other fields	High correlation
`jp_management_large_class` is highly correlated with `country_code` and 3 other fields	High correlation
`jp_management_small_class` is highly correlated with `country_code` and 5 other fields	High correlation
`jp_hco_hpgp_class` is highly correlated with `country_code` and 5 other fields	High correlation
`jp_hco_class` is highly correlated with `country_code` and 3 other fields	High correlation
`jp_hco_kind_code` is highly correlated with `country_code` and 6 other fields	High correlation
`jp_hco_kind` is highly correlated with `country_code` and 6 other fields	High correlation
`jp_psychiatric_ward_nursing_type` is highly correlated with `jp_management_small_class`	High correlation
`jp_hco_pharmacy_class` is highly correlated with `country_code` and 3 other fields	High correlation
`jp_psychosis_hospital_bed_number` is highly correlated with `jp_management_small_class`	High correlation
`record_type_name` is highly correlated with `country_code` and 1 other fields	High correlation
`state` is highly correlated with `country_code` and 2 other fields	High correlation
`jp_prefecture_code` is highly correlated with `country_code` and 2 other fields	High correlation
`jp_redai_prefecture_code` is highly correlated with `country_code` and 5 other fields	High correlation
`hco_business_id` has 16401 (2.9%) missing values	Missing
`inactive_reason` has 571989 (100.0%) missing values	Missing
`hco_type` has 16401 (2.9%) missing values	Missing
`hco_type_english_name` has 571989 (100.0%) missing values	Missing
`sector` has 571989 (100.0%) missing values	Missing
`phone_number` has 12683 (2.2%) missing values	Missing
`fax_number` has 571989 (100.0%) missing values	Missing
`website` has 571989 (100.0%) missing values	Missing
`territory_name` has 571988 (> 99.9%) missing values	Missing
`remarks` has 571989 (100.0%) missing values	Missing
`beds` has 309343 (54.1%) missing values	Missing
`jp_hco_category` has 16401 (2.9%) missing values	Missing
`jp_hco_id` has 16401 (2.9%) missing values	Missing
`jp_hospital_type` has 17938 (3.1%) missing values	Missing
`jp_account_furigana` has 8498 (1.5%) missing values	Missing
`jp_hco_name_kana` has 8572 (1.5%) missing values	Missing
`jp_hco_shortname` has 8582 (1.5%) missing values	Missing
`jp_hco_shortname_kana` has 8620 (1.5%) missing values	Missing
`jp_management_large_class` has 102766 (18.0%) missing values	Missing
`jp_management_small_class` has 102766 (18.0%) missing values	Missing
`jp_hco_hpgp_class` has 17938 (3.1%) missing values	Missing
`jp_hco_class` has 25936 (4.5%) missing values	Missing
`jp_hco_kind_code` has 325493 (56.9%) missing values	Missing
`jp_hco_kind` has 325493 (56.9%) missing values	Missing
`jp_psychiatric_ward_nursing_type` has 571986 (> 99.9%) missing values	Missing
`jp_related_univ_parent` has 570747 (99.8%) missing values	Missing
`jp_open_close_business_date` has 570253 (99.7%) missing values	Missing
`jp_hco_rep_code` has 371832 (65.0%) missing values	Missing
`jp_hco_rep_kana` has 195961 (34.3%) missing values	Missing
`jp_hco_rep_kanji` has 195952 (34.3%) missing values	Missing
`jp_hco_pharmacy_class` has 25122 (4.4%) missing values	Missing
`hco_dcf_cd` has 17937 (3.1%) missing values	Missing
`jp_duplicate_hco_code` has 558552 (97.7%) missing values	Missing
`jp_permitted_beds` has 394927 (69.0%) missing values	Missing
`jp_psychiatric_ward_number` has 571988 (> 99.9%) missing values	Missing
`jp_psychosis_hospital_bed_number` has 571986 (> 99.9%) missing values	Missing
`address_line_1` has 8457 (1.5%) missing values	Missing
`address_line_2` has 571988 (> 99.9%) missing values	Missing
`suburb_town` has 571988 (> 99.9%) missing values	Missing
`city` has 8853 (1.5%) missing values	Missing
`state` has 8896 (1.6%) missing values	Missing
`postcode` has 9617 (1.7%) missing values	Missing
`brick` has 571988 (> 99.9%) missing values	Missing
`map` has 8457 (1.5%) missing values	Missing
`appt_required_flag` has 8457 (1.5%) missing values	Missing
`address_phone` has 12825 (2.2%) missing values	Missing
`address_fax` has 571988 (> 99.9%) missing values	Missing
`primary_flag` has 8457 (1.5%) missing values	Missing
`jp_prefecture_code` has 8895 (1.6%) missing values	Missing
`jp_local_area_code` has 8949 (1.6%) missing values	Missing
`jp_city_code` has 8853 (1.5%) missing values	Missing
`jp_redai_prefecture_code` has 571863 (> 99.9%) missing values	Missing
`jp_larger_section_code` has 9214 (1.6%) missing values	Missing
`jp_smaller_section_code` has 9261 (1.6%) missing values	Missing
`jp_address_furigana` has 9727 (1.7%) missing values	Missing
`hco_business_id` is uniformly distributed	Uniform
`phone_number` is uniformly distributed	Uniform
`jp_hco_id` is uniformly distributed	Uniform
`jp_hco_rep_code` is uniformly distributed	Uniform
`hco_dcf_cd` is uniformly distributed	Uniform
`jp_duplicate_hco_code` is uniformly distributed	Uniform
`parent_hco_key` is uniformly distributed	Uniform
`address_phone` is uniformly distributed	Uniform
`hco_key` has unique values	Unique
`hco_source_id` has unique values	Unique
`inactive_reason` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`hco_type_english_name` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`sector` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`fax_number` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`website` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`remarks` is an unsupported type, check if it needs cleaning or further analysis	Unsupported

hco_key
Categorical

UNIQUE

Distinct count	571989
Unique (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	4.4 MiB

ebf2370765ab5e9044bd7e37ac0144bb	1
e32f66bde67cc1c2958aee567ec83912	1
80cf6f35d5d855d3b8092bce0f2558d1	1
c343fb1603092d9ec329d585a937f1f9	1
5330cf3f61ba5fb16cd5e6583eb29fbe	1
Other values (571984)	571984

Value	Count	Frequency (%)
ebf2370765ab5e9044bd7e37ac0144bb	1	< 0.1%
e32f66bde67cc1c2958aee567ec83912	1	< 0.1%
80cf6f35d5d855d3b8092bce0f2558d1	1	< 0.1%
c343fb1603092d9ec329d585a937f1f9	1	< 0.1%
5330cf3f61ba5fb16cd5e6583eb29fbe	1	< 0.1%
9bf21117773499546dccf773c03499ed	1	< 0.1%
140cf9d565c57a063b797051b6006c53	1	< 0.1%
a2bbb956396b67a2bbe1940be96b00c4	1	< 0.1%
c125c033f32692b3329b77a53bdd8249	1	< 0.1%
3caa42a79dd0e9a5c381d9a4ddcb6d5b	1	< 0.1%
Other values (571979)	571979	> 99.9%

Length

Max length	32
Median length	32
Mean length	31.99996853
Min length	14

country_code
Categorical

HIGH CORRELATION

Distinct count	2
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.4 MiB

JP	571988
ZZ	1

Value	Count	Frequency (%)
JP	571988	> 99.9%
ZZ	1	< 0.1%

Length

Max length	2
Median length	2
Mean length	2
Min length	2

hco_source_id
Categorical

UNIQUE

Distinct count	571989
Unique (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	4.4 MiB

0011000000Ui0leAAB	1
0015F000017ZO5FQAW	1
00110000013KeubAAC	1
0011000000UiLwRAAV	1
0011000000UOHV5AAP	1
Other values (571984)	571984

Value	Count	Frequency (%)
0011000000Ui0leAAB	1	< 0.1%
0015F000017ZO5FQAW	1	< 0.1%
00110000013KeubAAC	1	< 0.1%
0011000000UiLwRAAV	1	< 0.1%
0011000000UOHV5AAP	1	< 0.1%
0011000000UfVUeAAN	1	< 0.1%
0011000000UiEhUAAV	1	< 0.1%
0011000000UOJexAAH	1	< 0.1%
0011000000UgWINAA3	1	< 0.1%
0011000000UfeswAAB	1	< 0.1%
Other values (571979)	571979	> 99.9%

Length

Max length	18
Median length	18
Mean length	17.99999301
Min length	14

modify_id
Categorical

HIGH CARDINALITY

Distinct count	761
Unique (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.4 MiB

00510000000br12AAA	561096
00510000000bxB6AAI	1498
00510000000bxABAAY	1270
00510000002GX6yAAG	270
00510000000bx90AAA	257
Other values (756)	7598

Value	Count	Frequency (%)
00510000000br12AAA	561096	98.1%
00510000000bxB6AAI	1498	0.3%
00510000000bxABAAY	1270	0.2%
00510000002GX6yAAG	270	< 0.1%
00510000000bx90AAA	257	< 0.1%
00510000000bx7tAAA	235	< 0.1%
00510000000bx4HAAQ	211	< 0.1%
00510000000bxC8AAI	191	< 0.1%
00510000000bx6PAAQ	174	< 0.1%
00510000000bxCOAAY	167	< 0.1%
Other values (751)	6620	1.2%

Length

Max length	18
Median length	18
Mean length	17.99999301
Min length	14

modify_dt
Date

Distinct count	14924
Unique (%)	2.6%
Missing	0
Missing (%)	0.0%
Memory size	4.4 MiB

Minimum	2014-02-14 01:26:20
Maximum	2021-03-22 16:49:05.119017

Histogram

Histogram

hco_business_id
Categorical

HIGH CARDINALITY
MISSING
UNIFORM

Distinct count	555511
Unique (%)	> 99.9%
Missing	16401
Missing (%)	2.9%
Memory size	4.4 MiB

188	2
256	2
321	2
125	2
072	2
Other values (555506)	555578

Value	Count	Frequency (%)
188	2	< 0.1%
256	2	< 0.1%
321	2	< 0.1%
125	2	< 0.1%
072	2	< 0.1%
253	2	< 0.1%
250	2	< 0.1%
169	2	< 0.1%
202	2	< 0.1%
033	2	< 0.1%
Other values (555501)	555568	97.1%
(Missing)	16401	2.9%

Length

Max length	14
Median length	7
Mean length	6.882398088
Min length	3

inactive_flag
Boolean

CONSTANT
REJECTED

Distinct count	1
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.2 MiB

0	571989

Frequency Table

Value	Count	Frequency (%)
0	571989	100.0%

inactive_reason
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	571989
Missing (%)	100.0%
Memory size	4.4 MiB

hco_name
Categorical

HIGH CARDINALITY

Distinct count	443574
Unique (%)	77.5%
Missing	0
Missing (%)	0.0%
Memory size	4.4 MiB

不明	866
鈴木歯科医院	260
田中歯科医院	245
ひまわり薬局	222
佐藤歯科医院	217
Other values (443569)	570179

Value	Count	Frequency (%)
不明	866	0.2%
鈴木歯科医院	260	< 0.1%
田中歯科医院	245	< 0.1%
ひまわり薬局	222	< 0.1%
佐藤歯科医院	217	< 0.1%
小林歯科医院	212	< 0.1%
山本歯科医院	212	< 0.1%
中村歯科医院	188	< 0.1%
吉田歯科医院	172	< 0.1%
加藤歯科医院	166	< 0.1%
Other values (443564)	569229	99.5%

Length

Max length	39
Median length	10
Mean length	9.906485964
Min length	1

hco_type
Categorical

HIGH CORRELATION
MISSING

Distinct count	7
Unique (%)	< 0.1%
Missing	16401
Missing (%)	2.9%
Memory size	4.4 MiB

アルトマーク施設	546096
アルトマーク購入外施設	8972
学会(学会事務局)	336
流通業者(組織)	125
医師会	47
Other values (2)	12

Value	Count	Frequency (%)
アルトマーク施設	546096	95.5%
アルトマーク購入外施設	8972	1.6%
学会(学会事務局)	336	0.1%
流通業者(組織)	125	< 0.1%
医師会	47	< 0.1%
患者団体	11	< 0.1%
Not Applicable	1	< 0.1%
(Missing)	16401	2.9%

Length

Max length	14
Median length	8
Mean length	7.903798849
Min length	3

hco_type_english_name
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	571989
Missing (%)	100.0%
Memory size	4.4 MiB

sector
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	571989
Missing (%)	100.0%
Memory size	4.4 MiB

phone_number
Categorical

HIGH CARDINALITY
MISSING
UNIFORM

Distinct count	478218
Unique (%)	85.5%
Missing	12683
Missing (%)	2.2%
Memory size	4.4 MiB

0	58
011-716-2111	26
092-641-1151	26
00-0000-0000	25
03-3813-6111	24
Other values (478213)	559147

Value	Count	Frequency (%)
0	58	< 0.1%
011-716-2111	26	< 0.1%
092-641-1151	26	< 0.1%
00-0000-0000	25	< 0.1%
03-3813-6111	24	< 0.1%
019-651-5111	22	< 0.1%
03-3353-8111	22	< 0.1%
025-223-6161	21	< 0.1%
06-6877-5111	20	< 0.1%
03-3434-7681	20	< 0.1%
Other values (478208)	559042	97.7%
(Missing)	12683	2.2%

Length

Max length	15
Median length	12
Mean length	11.79890348
Min length	1

fax_number
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	571989
Missing (%)	100.0%
Memory size	4.4 MiB

website
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	571989
Missing (%)	100.0%
Memory size	4.4 MiB

territory_name
Categorical

MISSING

Distinct count	1
Unique (%)	100.0%
Missing	571988
Missing (%)	> 99.9%
Memory size	4.4 MiB

Not Applicable	1

Value	Count	Frequency (%)
Not Applicable	1	< 0.1%
(Missing)	571988	> 99.9%

Length

Max length	14
Median length	3
Mean length	3.000019231
Min length	3

formatted_name
Categorical

HIGH CARDINALITY

Distinct count	443574
Unique (%)	77.5%
Missing	0
Missing (%)	0.0%
Memory size	4.4 MiB

不明	866
鈴木歯科医院	260
田中歯科医院	245
ひまわり薬局	222
佐藤歯科医院	217
Other values (443569)	570179

Value	Count	Frequency (%)
不明	866	0.2%
鈴木歯科医院	260	< 0.1%
田中歯科医院	245	< 0.1%
ひまわり薬局	222	< 0.1%
佐藤歯科医院	217	< 0.1%
小林歯科医院	212	< 0.1%
山本歯科医院	212	< 0.1%
中村歯科医院	188	< 0.1%
吉田歯科医院	172	< 0.1%
加藤歯科医院	166	< 0.1%
Other values (443564)	569229	99.5%

Length

Max length	39
Median length	10
Mean length	9.906485964
Min length	1

remarks
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	571989
Missing (%)	100.0%
Memory size	4.4 MiB

beds
Categorical

HIGH CARDINALITY
MISSING

Distinct count	707
Unique (%)	0.3%
Missing	309343
Missing (%)	54.1%
Memory size	4.4 MiB

0	229217
19	4706
50	3945
100	2295
80	1377
Other values (702)	21106

Value	Count	Frequency (%)
0	229217	40.1%
19	4706	0.8%
50	3945	0.7%
100	2295	0.4%
80	1377	0.2%
60	905	0.2%
70	626	0.1%
3	607	0.1%
10	599	0.1%
18	510	0.1%
Other values (697)	17859	3.1%
(Missing)	309343	54.1%

Length

Max length	4
Median length	3
Mean length	2.148892723
Min length	1

jp_hco_category
Categorical

HIGH CORRELATION
MISSING

Distinct count	7
Unique (%)	< 0.1%
Missing	16401
Missing (%)	2.9%
Memory size	4.4 MiB

アルトマーク施設	546096
アルトマーク購入外施設	8972
学会(学会事務局)	336
流通業者(組織)	125
医師会	47
Other values (2)	12

Value	Count	Frequency (%)
アルトマーク施設	546096	95.5%
アルトマーク購入外施設	8972	1.6%
学会(学会事務局)	336	0.1%
流通業者(組織)	125	< 0.1%
医師会	47	< 0.1%
患者団体	11	< 0.1%
Not Applicable	1	< 0.1%
(Missing)	16401	2.9%

Length

Max length	14
Median length	8
Mean length	7.903798849
Min length	3

jp_hco_id
Categorical

HIGH CARDINALITY
MISSING
UNIFORM

Distinct count	555511
Unique (%)	> 99.9%
Missing	16401
Missing (%)	2.9%
Memory size	4.4 MiB

188	2
256	2
321	2
125	2
072	2
Other values (555506)	555578

Value	Count	Frequency (%)
188	2	< 0.1%
256	2	< 0.1%
321	2	< 0.1%
125	2	< 0.1%
072	2	< 0.1%
253	2	< 0.1%
250	2	< 0.1%
169	2	< 0.1%
202	2	< 0.1%
033	2	< 0.1%
Other values (555501)	555568	97.1%
(Missing)	16401	2.9%

Length

Max length	10
Median length	7
Mean length	6.882377109
Min length	2

jp_hospital_type
Categorical

HIGH CORRELATION
MISSING

Distinct count	3
Unique (%)	< 0.1%
Missing	17938
Missing (%)	3.1%
Memory size	4.4 MiB

GP	548088
HP	5962
Not Applicable	1

Value	Count	Frequency (%)
GP	548088	95.8%
HP	5962	1.0%
Not Applicable	1	< 0.1%
(Missing)	17938	3.1%

Length

Max length	14
Median length	2
Mean length	2.031381722
Min length	2

jp_account_furigana
Categorical

HIGH CARDINALITY
MISSING

Distinct count	412648
Unique (%)	73.2%
Missing	8498
Missing (%)	1.5%
Memory size	4.4 MiB

スズキシカイイン	296
タナカシカイイン	289
サトウシカイイン	286
ヤマモトシカイイン	236
コバヤシシカイイン	235
Other values (412643)	562149

Value	Count	Frequency (%)
スズキシカイイン	296	0.1%
タナカシカイイン	289	0.1%
サトウシカイイン	286	0.1%
ヤマモトシカイイン	236	< 0.1%
コバヤシシカイイン	235	< 0.1%
タカハシシカイイン	235	< 0.1%
ワタナベシカイイン	226	< 0.1%
イトウシカイイン	225	< 0.1%
ヒマワリヤツキヨク	221	< 0.1%
ナカムラシカイイン	220	< 0.1%
Other values (412638)	561022	98.1%
(Missing)	8498	1.5%

Length

Max length	40
Median length	14
Mean length	14.09853336
Min length	1

jp_hco_name
Categorical

HIGH CARDINALITY

Distinct count	484174
Unique (%)	85.3%
Missing	4250
Missing (%)	0.7%
Memory size	4.4 MiB

不明	291
鈴木歯科医院	258
田中歯科医院	243
佐藤歯科医院	213
山本歯科医院	212
Other values (484169)	566522

Value	Count	Frequency (%)
不明	291	0.1%
鈴木歯科医院	258	< 0.1%
田中歯科医院	243	< 0.1%
佐藤歯科医院	213	< 0.1%
山本歯科医院	212	< 0.1%
小林歯科医院	212	< 0.1%
中村歯科医院	188	< 0.1%
吉田歯科医院	172	< 0.1%
加藤歯科医院	166	< 0.1%
山田歯科医院	163	< 0.1%
Other values (484164)	565621	98.9%
(Missing)	4250	0.7%

Length

Max length	62
Median length	12
Mean length	13.64364
Min length	1

jp_hco_name_kana
Categorical

HIGH CARDINALITY
MISSING

Distinct count	461518
Unique (%)	81.9%
Missing	8572
Missing (%)	1.5%
Memory size	4.4 MiB

ｽｽﾞｷｼｶｲｲﾝ	295
ﾀﾅｶｼｶｲｲﾝ	287
ｻﾄｳｼｶｲｲﾝ	284
ﾔﾏﾓﾄｼｶｲｲﾝ	236
ｺﾊﾞﾔｼｼｶｲｲﾝ	235
Other values (461513)	562080

Value	Count	Frequency (%)
ｽｽﾞｷｼｶｲｲﾝ	295	0.1%
ﾀﾅｶｼｶｲｲﾝ	287	0.1%
ｻﾄｳｼｶｲｲﾝ	284	< 0.1%
ﾔﾏﾓﾄｼｶｲｲﾝ	236	< 0.1%
ｺﾊﾞﾔｼｼｶｲｲﾝ	235	< 0.1%
ﾀｶﾊｼｼｶｲｲﾝ	233	< 0.1%
ﾜﾀﾅﾍﾞｼｶｲｲﾝ	226	< 0.1%
ｲﾄｳｼｶｲｲﾝ	223	< 0.1%
ﾅｶﾑﾗｼｶｲｲﾝ	221	< 0.1%
ﾖｼﾀﾞｼｶｲｲﾝ	201	< 0.1%
Other values (461508)	560976	98.1%
(Missing)	8572	1.5%

Length

Max length	80
Median length	20
Mean length	21.91655784
Min length	1

jp_hco_shortname
Categorical

HIGH CARDINALITY
MISSING

Distinct count	439543
Unique (%)	78.0%
Missing	8582
Missing (%)	1.5%
Memory size	4.4 MiB

鈴木歯科医院	259
田中歯科医院	245
佐藤歯科医院	215
ひまわり薬局	214
小林歯科医院	212
Other values (439538)	562262

Value	Count	Frequency (%)
鈴木歯科医院	259	< 0.1%
田中歯科医院	245	< 0.1%
佐藤歯科医院	215	< 0.1%
ひまわり薬局	214	< 0.1%
小林歯科医院	212	< 0.1%
山本歯科医院	212	< 0.1%
中村歯科医院	188	< 0.1%
吉田歯科医院	172	< 0.1%
加藤歯科医院	166	< 0.1%
山田歯科医院	163	< 0.1%
Other values (439533)	561361	98.1%
(Missing)	8582	1.5%

Length

Max length	29
Median length	10
Mean length	9.825648745
Min length	1

jp_hco_shortname_kana
Categorical

HIGH CARDINALITY
MISSING

Distinct count	412587
Unique (%)	73.2%
Missing	8620
Missing (%)	1.5%
Memory size	4.4 MiB

ｽｽﾞｷｼｶｲｲﾝ	296
ﾀﾅｶｼｶｲｲﾝ	289
ｻﾄｳｼｶｲｲﾝ	286
ﾔﾏﾓﾄｼｶｲｲﾝ	236
ﾀｶﾊｼｼｶｲｲﾝ	235
Other values (412582)	562027

Value	Count	Frequency (%)
ｽｽﾞｷｼｶｲｲﾝ	296	0.1%
ﾀﾅｶｼｶｲｲﾝ	289	0.1%
ｻﾄｳｼｶｲｲﾝ	286	0.1%
ﾔﾏﾓﾄｼｶｲｲﾝ	236	< 0.1%
ﾀｶﾊｼｼｶｲｲﾝ	235	< 0.1%
ｺﾊﾞﾔｼｼｶｲｲﾝ	235	< 0.1%
ﾜﾀﾅﾍﾞｼｶｲｲﾝ	226	< 0.1%
ｲﾄｳｼｶｲｲﾝ	225	< 0.1%
ﾋﾏﾜﾘﾔﾂｷﾖｸ	221	< 0.1%
ﾅｶﾑﾗｼｶｲｲﾝ	220	< 0.1%
Other values (412577)	560900	98.1%
(Missing)	8620	1.5%

Length

Max length	40
Median length	15
Mean length	15.45346327
Min length	1

jp_management_large_class
Categorical

HIGH CORRELATION
MISSING

Distinct count	5
Unique (%)	< 0.1%
Missing	102766
Missing (%)	18.0%
Memory size	4.4 MiB

その他	444554
公的	18581
社会保険	3592
国立	2495
Not Applicable	1

Value	Count	Frequency (%)
その他	444554	77.7%
公的	18581	3.2%
社会保険	3592	0.6%
国立	2495	0.4%
Not Applicable	1	< 0.1%
(Missing)	102766	18.0%

Length

Max length	14
Median length	3
Mean length	2.96945221
Min length	2

jp_management_small_class
Categorical

HIGH CARDINALITY
HIGH CORRELATION
MISSING

Distinct count	63
Unique (%)	< 0.1%
Missing	102766
Missing (%)	18.0%
Memory size	4.4 MiB

個人	160231
会社	147694
医療	91732
社福	35423
市立	9156
Other values (58)	24987

Value	Count	Frequency (%)
個人	160231	28.0%
会社	147694	25.8%
医療	91732	16.0%
社福	35423	6.2%
市立	9156	1.6%
町立	3793	0.7%
健保	2408	0.4%
財団	2001	0.3%
県立	1561	0.3%
学校	1479	0.3%
Other values (53)	13745	2.4%
(Missing)	102766	18.0%

Length

Max length	14
Median length	2
Mean length	2.187344512
Min length	2

jp_hco_hpgp_class
Categorical

HIGH CORRELATION
MISSING

Distinct count	3
Unique (%)	< 0.1%
Missing	17938
Missing (%)	3.1%
Memory size	4.4 MiB

GP	548088
HP	5962
Not Applicable	1

Value	Count	Frequency (%)
GP	548088	95.8%
HP	5962	1.0%
Not Applicable	1	< 0.1%
(Missing)	17938	3.1%

Length

Max length	14
Median length	2
Mean length	2.031381722
Min length	2

jp_hco_class
Categorical

HIGH CARDINALITY
HIGH CORRELATION
MISSING

Distinct count	89
Unique (%)	< 0.1%
Missing	25936
Missing (%)	4.5%
Memory size	4.4 MiB

一般診療所	144448
調剤薬局	99310
歯科診療所	75751
店舗販売業（Ｂ）（旧薬種商販売業）	41296
店舗販売業（Ａ）	20887
Other values (84)	164361

Value	Count	Frequency (%)
一般診療所	144448	25.3%
調剤薬局	99310	17.4%
歯科診療所	75751	13.2%
店舗販売業（Ｂ）（旧薬種商販売業）	41296	7.2%
店舗販売業（Ａ）	20887	3.7%
グループホーム	12205	2.1%
病院（大学ＨＰ以外）	10980	1.9%
老人デイサービスセンター（ケアセンター）	10713	1.9%
特別養護老人ホーム等医務室	10310	1.8%
卸会社	9600	1.7%
Other values (79)	110553	19.3%
(Missing)	25936	4.5%

Length

Max length	24
Median length	5
Mean length	6.906513936
Min length	1

jp_hco_kind_code
Categorical

HIGH CORRELATION
MISSING

Distinct count	9
Unique (%)	< 0.1%
Missing	325493
Missing (%)	56.9%
Memory size	4.4 MiB

7	135351
9	101428
1	8552
2	1141
4	14
Other values (4)	10

Value	Count	Frequency (%)
7	135351	23.7%
9	101428	17.7%
1	8552	1.5%
2	1141	0.2%
4	14	< 0.1%
5	4	< 0.1%
3	3	< 0.1%
6	2	< 0.1%
Not Applicable	1	< 0.1%
(Missing)	325493	56.9%

Length

Max length	14
Median length	3
Mean length	2.138132027
Min length	1

jp_hco_kind
Categorical

HIGH CORRELATION
MISSING

Distinct count	9
Unique (%)	< 0.1%
Missing	325493
Missing (%)	56.9%
Memory size	4.4 MiB

診療所	135351
その他	101428
一般	8552
精神	1141
ハンセン	14
Other values (4)	10

Value	Count	Frequency (%)
診療所	135351	23.7%
その他	101428	17.7%
一般	8552	1.5%
精神	1141	0.2%
ハンセン	14	< 0.1%
伝染	4	< 0.1%
結核	3	< 0.1%
歯科	2	< 0.1%
Not Applicable	1	< 0.1%
(Missing)	325493	56.9%

Length

Max length	14
Median length	3
Mean length	2.983081842
Min length	2

jp_psychiatric_ward_nursing_type
Categorical

HIGH CORRELATION
MISSING

Distinct count	2
Unique (%)	66.7%
Missing	571986
Missing (%)	> 99.9%
Memory size	4.4 MiB

M999	2
Not Applicable	1

Value	Count	Frequency (%)
M999	2	< 0.1%
Not Applicable	1	< 0.1%
(Missing)	571986	> 99.9%

Length

Max length	14
Median length	3
Mean length	3.000022728
Min length	3

jp_related_univ_parent
Categorical

HIGH CARDINALITY
MISSING

Distinct count	195
Unique (%)	15.7%
Missing	570747
Missing (%)	99.8%
Memory size	4.4 MiB

5302823	40
3613814	32
5408060	32
8104657	29
3613809	25
Other values (190)	1084

Value	Count	Frequency (%)
5302823	40	< 0.1%
3613814	32	< 0.1%
5408060	32	< 0.1%
8104657	29	< 0.1%
3613809	25	< 0.1%
2301487	20	< 0.1%
3613816	20	< 0.1%
1103759	20	< 0.1%
3704831	19	< 0.1%
4904355	18	< 0.1%
Other values (185)	987	0.2%
(Missing)	570747	99.8%

Length

Max length	14
Median length	3
Mean length	3.00869772
Min length	3

jp_open_close_business_date
Categorical

HIGH CARDINALITY
MISSING

Distinct count	175
Unique (%)	10.1%
Missing	570253
Missing (%)	99.7%
Memory size	4.4 MiB

202104	224
202103	115
202102	110
202009	77
202101	68
Other values (170)	1142

Value	Count	Frequency (%)
202104	224	< 0.1%
202103	115	< 0.1%
202102	110	< 0.1%
202009	77	< 0.1%
202101	68	< 0.1%
202012	67	< 0.1%
202002	54	< 0.1%
202105	47	< 0.1%
202001	43	< 0.1%
202006	43	< 0.1%
Other values (165)	888	0.2%
(Missing)	570253	99.7%

Length

Max length	6
Median length	3
Mean length	3.00909458
Min length	2

jp_hco_rep_code
Categorical

HIGH CARDINALITY
MISSING
UNIFORM

Distinct count	188418
Unique (%)	94.1%
Missing	371832
Missing (%)	65.0%
Memory size	4.4 MiB

284757	9
144553	7
153438	6
297935	6
221424	6
Other values (188413)	200123

Value	Count	Frequency (%)
284757	9	< 0.1%
144553	7	< 0.1%
153438	6	< 0.1%
297935	6	< 0.1%
221424	6	< 0.1%
308301	6	< 0.1%
126209	5	< 0.1%
190108	5	< 0.1%
622466	5	< 0.1%
249910	5	< 0.1%
Other values (188408)	200097	35.0%
(Missing)	371832	65.0%

Length

Max length	14
Median length	3
Mean length	4.04980865
Min length	3

jp_hco_rep_kana
Categorical

HIGH CARDINALITY
MISSING

Distinct count	211186
Unique (%)	56.2%
Missing	195961
Missing (%)	34.3%
Memory size	4.4 MiB

ﾏﾂﾓﾄﾀﾀﾞﾋｻ	2017
ﾂｶﾓﾄｱﾂｼ	1559
ｽｷﾞｳﾗｶﾂﾉﾘ	1423
ﾔﾊﾀﾏｻﾋﾛ	1292
ﾖｺﾔﾏﾋﾃﾞｱｷ	1152
Other values (211181)	368585

Value	Count	Frequency (%)
ﾏﾂﾓﾄﾀﾀﾞﾋｻ	2017	0.4%
ﾂｶﾓﾄｱﾂｼ	1559	0.3%
ｽｷﾞｳﾗｶﾂﾉﾘ	1423	0.2%
ﾔﾊﾀﾏｻﾋﾛ	1292	0.2%
ﾖｺﾔﾏﾋﾃﾞｱｷ	1152	0.2%
ｻﾀﾞｶﾀﾋﾛｼ	1033	0.2%
ｵｵｲｼﾐﾔ	1008	0.2%
ｵｵﾀﾀｶｵ	980	0.2%
ﾀｶﾔﾅｷﾞﾏｻﾕｷ	805	0.1%
ﾓﾘｶﾅﾒ	768	0.1%
Other values (211176)	363991	63.6%
(Missing)	195961	34.3%

Length

Max length	20
Median length	8
Mean length	6.827126046
Min length	3

jp_hco_rep_kanji
Categorical

HIGH CARDINALITY
MISSING

Distinct count	247490
Unique (%)	65.8%
Missing	195952
Missing (%)	34.3%
Memory size	4.4 MiB

松本　忠久	2020
塚本　厚志	1559
杉浦　克典	1423
八幡　政浩	1292
横山　英昭	1150
Other values (247485)	368593

Value	Count	Frequency (%)
松本　忠久	2020	0.4%
塚本　厚志	1559	0.3%
杉浦　克典	1423	0.2%
八幡　政浩	1292	0.2%
横山　英昭	1150	0.2%
大石　美也	1087	0.2%
貞方　宏司	1033	0.2%
大田　貴雄	981	0.2%
高柳　昌幸	810	0.1%
森　要	768	0.1%
Other values (247480)	363914	63.6%
(Missing)	195952	34.3%

Length

Max length	20
Median length	5
Mean length	4.344251375
Min length	3

jp_hco_pharmacy_class
Categorical

HIGH CORRELATION
MISSING

Distinct count	4
Unique (%)	< 0.1%
Missing	25122
Missing (%)	4.4%
Memory size	4.4 MiB

病院	247099
薬局薬店	212685
歯科	87082
Not Applicable	1

Value	Count	Frequency (%)
病院	247099	43.2%
薬局薬店	212685	37.2%
歯科	87082	15.2%
Not Applicable	1	< 0.1%
(Missing)	25122	4.4%

Length

Max length	14
Median length	2
Mean length	2.787609552
Min length	2

hco_dcf_cd
Categorical

HIGH CARDINALITY
MISSING
UNIFORM

Distinct count	554052
Unique (%)	100.0%
Missing	17937
Missing (%)	3.1%
Memory size	4.4 MiB

3695800	1
5602716	1
8107638	1
8871402	1
4875830	1
Other values (554047)	554047

Value	Count	Frequency (%)
3695800	1	< 0.1%
5602716	1	< 0.1%
8107638	1	< 0.1%
8871402	1	< 0.1%
4875830	1	< 0.1%
5410385	1	< 0.1%
3770407	1	< 0.1%
3778060	1	< 0.1%
8302305	1	< 0.1%
0198054	1	< 0.1%
Other values (554042)	554042	96.9%
(Missing)	17937	3.1%

Length

Max length	14
Median length	7
Mean length	6.874578008
Min length	3

jp_duplicate_hco_code
Categorical

HIGH CARDINALITY
MISSING
UNIFORM

Distinct count	13366
Unique (%)	99.5%
Missing	558552
Missing (%)	97.7%
Memory size	4.4 MiB

0202955	3
0200953	3
0203403	3
0212941	3
3693616	3
Other values (13361)	13422

Value	Count	Frequency (%)
0202955	3	< 0.1%
0200953	3	< 0.1%
0203403	3	< 0.1%
0212941	3	< 0.1%
3693616	3	< 0.1%
0228126	3	< 0.1%
3685647	3	< 0.1%
5512523	2	< 0.1%
3694888	2	< 0.1%
4100875	2	< 0.1%
Other values (13356)	13410	2.3%
(Missing)	558552	97.7%

Length

Max length	7
Median length	3
Mean length	3.093958101
Min length	2

jp_permitted_beds
Categorical

HIGH CARDINALITY
MISSING

Distinct count	728
Unique (%)	0.4%
Missing	394927
Missing (%)	69.0%
Memory size	4.4 MiB

0	155967
19	4457
3	583
10	531
9	462
Other values (723)	15062

Value	Count	Frequency (%)
0	155967	27.3%
19	4457	0.8%
3	583	0.1%
10	531	0.1%
9	462	0.1%
2	461	0.1%
18	452	0.1%
5	427	0.1%
8	423	0.1%
60	394	0.1%
Other values (718)	12905	2.3%
(Missing)	394927	69.0%

Length

Max length	4
Median length	3
Mean length	2.421803566
Min length	1

jp_psychiatric_ward_number
Categorical

MISSING

Distinct count	1
Unique (%)	100.0%
Missing	571988
Missing (%)	> 99.9%
Memory size	4.4 MiB

0	1

Value	Count	Frequency (%)
0	1	< 0.1%
(Missing)	571988	> 99.9%

Length

Max length	3
Median length	3
Mean length	2.999996503
Min length	1

jp_psychosis_hospital_bed_number
Categorical

HIGH CORRELATION
MISSING

Distinct count	2
Unique (%)	66.7%
Missing	571986
Missing (%)	> 99.9%
Memory size	4.4 MiB

90	2
0	1

Value	Count	Frequency (%)
90	2	< 0.1%
0	1	< 0.1%
(Missing)	571986	> 99.9%

Length

Max length	3
Median length	3
Mean length	2.999993007
Min length	1

record_type_name
Categorical

HIGH CORRELATION

Distinct count	11
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.4 MiB

Hospital	262978
Pharmacy	120438
Deleted_Pharmacy_jpkk	92164
Deleted_Hospital_jpkk	78470
Other_Group_jpkk	9357
Other values (6)	8582

Value	Count	Frequency (%)
Hospital	262978	46.0%
Pharmacy	120438	21.1%
Deleted_Pharmacy_jpkk	92164	16.1%
Deleted_Hospital_jpkk	78470	13.7%
Other_Group_jpkk	9357	1.6%
Dummy_CCHospital_jpkk	8435	1.5%
Distributor	125	< 0.1%
Dummy_Hospital_jpro	11	< 0.1%
Deleted_Other_Group_jpkk	9	< 0.1%
Not Applicable	1	< 0.1%

Length

Max length	24
Median length	8
Mean length	12.20185178
Min length	8

hco_external_id
Categorical

HIGH CARDINALITY

Distinct count	563543
Unique (%)	98.5%
Missing	0
Missing (%)	0.0%
Memory size	4.4 MiB

Not Applicable	8447
H6502127	1
H3631256	1
H6572526	1
H8179345	1
Other values (563538)	563538

Value	Count	Frequency (%)
Not Applicable	8447	1.5%
H6502127	1	< 0.1%
H3631256	1	< 0.1%
H6572526	1	< 0.1%
H8179345	1	< 0.1%
H5510278	1	< 0.1%
H2672944	1	< 0.1%
H0199697	1	< 0.1%
H5701903	1	< 0.1%
H4500047	1	< 0.1%
Other values (563533)	563533	98.5%

Length

Max length	14
Median length	8
Mean length	8.085686963
Min length	4

parent_hco_key
Categorical

HIGH CARDINALITY
UNIFORM

Distinct count	571988
Unique (%)	> 99.9%
Missing	0
Missing (%)	0.0%
Memory size	4.4 MiB

527c19146847d4779023703fb2870825	2
ebf2370765ab5e9044bd7e37ac0144bb	1
9bf21117773499546dccf773c03499ed	1
0a1b8b46bc93bdc591dfa97e339c6935	1
7d66f9043d8b75543891eb8c41cf0be0	1
Other values (571983)	571983

Value	Count	Frequency (%)
527c19146847d4779023703fb2870825	2	< 0.1%
ebf2370765ab5e9044bd7e37ac0144bb	1	< 0.1%
9bf21117773499546dccf773c03499ed	1	< 0.1%
0a1b8b46bc93bdc591dfa97e339c6935	1	< 0.1%
7d66f9043d8b75543891eb8c41cf0be0	1	< 0.1%
f3d16e58c7aecdd64b4a6b2f0af7100b	1	< 0.1%
80cf6f35d5d855d3b8092bce0f2558d1	1	< 0.1%
c343fb1603092d9ec329d585a937f1f9	1	< 0.1%
5330cf3f61ba5fb16cd5e6583eb29fbe	1	< 0.1%
140cf9d565c57a063b797051b6006c53	1	< 0.1%
Other values (571978)	571978	> 99.9%

Length

Max length	32
Median length	32
Mean length	31.99996853
Min length	14

parent_hco_name
Categorical

HIGH CARDINALITY

Distinct count	443573
Unique (%)	77.5%
Missing	0
Missing (%)	0.0%
Memory size	4.4 MiB

不明	866
鈴木歯科医院	260
田中歯科医院	245
ひまわり薬局	222
佐藤歯科医院	217
Other values (443568)	570179

Value	Count	Frequency (%)
不明	866	0.2%
鈴木歯科医院	260	< 0.1%
田中歯科医院	245	< 0.1%
ひまわり薬局	222	< 0.1%
佐藤歯科医院	217	< 0.1%
小林歯科医院	212	< 0.1%
山本歯科医院	212	< 0.1%
中村歯科医院	188	< 0.1%
吉田歯科医院	172	< 0.1%
加藤歯科医院	166	< 0.1%
Other values (443563)	569229	99.5%

Length

Max length	39
Median length	10
Mean length	9.906478971
Min length	1

deleted_flag
Boolean

CONSTANT
REJECTED

Distinct count	1
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.2 MiB

0	571989

Frequency Table

Value	Count	Frequency (%)
0	571989	100.0%

address_line_1
Categorical

HIGH CARDINALITY
MISSING

Distinct count	60991
Unique (%)	10.8%
Missing	8457
Missing (%)	1.5%
Memory size	4.4 MiB

レコード終了により更新停止	11111
記載なし	850
東京都中央区銀座	841
東京都新宿区西新宿	744
東京都新宿区新宿	501
Other values (60986)	549485

Value	Count	Frequency (%)
レコード終了により更新停止	11111	1.9%
記載なし	850	0.1%
東京都中央区銀座	841	0.1%
東京都新宿区西新宿	744	0.1%
東京都新宿区新宿	501	0.1%
東京都文京区本郷	500	0.1%
東京都港区赤坂	452	0.1%
福岡県福岡市中央区天神	421	0.1%
愛知県名古屋市中区栄	407	0.1%
大阪府大阪市北区梅田	338	0.1%
Other values (60981)	547367	95.7%
(Missing)	8457	1.5%

Length

Max length	22
Median length	10
Mean length	10.25193317
Min length	3

address_line_2
Categorical

MISSING

Distinct count	1
Unique (%)	100.0%
Missing	571988
Missing (%)	> 99.9%
Memory size	4.4 MiB

Not Applicable	1

Value	Count	Frequency (%)
Not Applicable	1	< 0.1%
(Missing)	571988	> 99.9%

Length

Max length	14
Median length	3
Mean length	3.000019231
Min length	3

suburb_town
Categorical

MISSING

Distinct count	1
Unique (%)	100.0%
Missing	571988
Missing (%)	> 99.9%
Memory size	4.4 MiB

Not Applicable	1

Value	Count	Frequency (%)
Not Applicable	1	< 0.1%
(Missing)	571988	> 99.9%

Length

Max length	14
Median length	3
Mean length	3.000019231
Min length	3

city
Categorical

HIGH CARDINALITY
MISSING

Distinct count	1345
Unique (%)	0.2%
Missing	8853
Missing (%)	1.5%
Memory size	4.4 MiB

世田谷区	4229
港区	3889
新宿区	3389
大田区	3294
鹿児島市	3248
Other values (1340)	545087

Value	Count	Frequency (%)
世田谷区	4229	0.7%
港区	3889	0.7%
新宿区	3389	0.6%
大田区	3294	0.6%
鹿児島市	3248	0.6%
中央区	3067	0.5%
千代田区	2948	0.5%
練馬区	2856	0.5%
渋谷区	2626	0.5%
長崎市	2600	0.5%
Other values (1335)	530990	92.8%
(Missing)	8853	1.5%

Length

Max length	14
Median length	3
Mean length	3.836673433
Min length	2

state
Categorical

HIGH CORRELATION
MISSING

Distinct count	49
Unique (%)	< 0.1%
Missing	8896
Missing (%)	1.6%
Memory size	4.4 MiB

東京都	71725
大阪府	42944
神奈川県	34562
愛知県	28738
福岡県	25661
Other values (44)	359463

Value	Count	Frequency (%)
東京都	71725	12.5%
大阪府	42944	7.5%
神奈川県	34562	6.0%
愛知県	28738	5.0%
福岡県	25661	4.5%
埼玉県	24931	4.4%
兵庫県	24319	4.3%
北海道	23785	4.2%
千葉県	21374	3.7%
静岡県	15148	2.6%
Other values (39)	249906	43.7%

Length

Max length	14
Median length	3
Mean length	3.083741121
Min length	2

postcode
Categorical

HIGH CARDINALITY
MISSING

Distinct count	62225
Unique (%)	11.1%
Missing	9617
Missing (%)	1.7%
Memory size	4.4 MiB

104-0061	843
160-0023	744
160-0022	501
113-0033	500
107-0052	449
Other values (62220)	559335

Value	Count	Frequency (%)
104-0061	843	0.1%
160-0023	744	0.1%
160-0022	501	0.1%
113-0033	500	0.1%
107-0052	449	0.1%
810-0001	421	0.1%
460-0008	407	0.1%
530-0001	338	0.1%
107-0062	335	0.1%
151-0053	302	0.1%
Other values (62215)	557532	97.5%
(Missing)	9617	1.7%

Length

Max length	14
Median length	8
Mean length	7.915113752
Min length	3

brick
Categorical

MISSING

Distinct count	1
Unique (%)	100.0%
Missing	571988
Missing (%)	> 99.9%
Memory size	4.4 MiB

Not Applicable	1

Value	Count	Frequency (%)
Not Applicable	1	< 0.1%
(Missing)	571988	> 99.9%

Length

Max length	14
Median length	3
Mean length	3.000019231
Min length	3

map
Categorical

HIGH CARDINALITY
MISSING

Distinct count	62234
Unique (%)	11.0%
Missing	8457
Missing (%)	1.5%
Memory size	4.4 MiB

<a href="http://maps.google.com/maps?f=q&hl=en&q=東京都中央区銀座+中央区" target="_blank">map</a>	841
<a href="http://maps.google.com/maps?f=q&hl=en&q=東京都新宿区西新宿+新宿区" target="_blank">map</a>	744
<a href="http://maps.google.com/maps?f=q&hl=en&q=東京都新宿区新宿+新宿区" target="_blank">map</a>	501
<a href="http://maps.google.com/maps?f=q&hl=en&q=東京都文京区本郷+文京区" target="_blank">map</a>	500
<a href="http://maps.google.com/maps?f=q&hl=en&q=東京都港区赤坂+港区" target="_blank">map</a>	452
Other values (62229)	560494

Value	Count	Frequency (%)
<a href="http://maps.google.com/maps?f=q&hl=en&q=東京都中央区銀座+中央区" target="_blank">map</a>	841	0.1%
<a href="http://maps.google.com/maps?f=q&hl=en&q=東京都新宿区西新宿+新宿区" target="_blank">map</a>	744	0.1%
<a href="http://maps.google.com/maps?f=q&hl=en&q=東京都新宿区新宿+新宿区" target="_blank">map</a>	501	0.1%
<a href="http://maps.google.com/maps?f=q&hl=en&q=東京都文京区本郷+文京区" target="_blank">map</a>	500	0.1%
<a href="http://maps.google.com/maps?f=q&hl=en&q=東京都港区赤坂+港区" target="_blank">map</a>	452	0.1%
<a href="http://maps.google.com/maps?f=q&hl=en&q=福岡県福岡市中央区天神+福岡市中央区" target="_blank">map</a>	421	0.1%
<a href="http://maps.google.com/maps?f=q&hl=en&q=愛知県名古屋市中区栄+名古屋市中区" target="_blank">map</a>	407	0.1%
<a href="http://maps.google.com/maps?f=q&hl=en&q=記載なし+" target="_blank">map</a>	396	0.1%
<a href="http://maps.google.com/maps?f=q&hl=en&q=大阪府大阪市北区梅田+大阪市北区" target="_blank">map</a>	338	0.1%
<a href="http://maps.google.com/maps?f=q&hl=en&q=東京都港区南青山+港区" target="_blank">map</a>	337	0.1%
Other values (62224)	558595	97.7%
(Missing)	8457	1.5%

Length

Max length	113
Median length	96
Mean length	95.81482861
Min length	3

hco_address_source_id
Categorical

HIGH CARDINALITY

Distinct count	563531
Unique (%)	98.5%
Missing	0
Missing (%)	0.0%
Memory size	4.4 MiB

Not Applicable	8458
a0110000009p0NDAAY	2
a0110000009qJRpAAM	1
a0110000009pD2SAAU	1
a0110000009pwYgAAI	1
Other values (563526)	563526

Value	Count	Frequency (%)
Not Applicable	8458	1.5%
a0110000009p0NDAAY	2	< 0.1%
a0110000009qJRpAAM	1	< 0.1%
a0110000009pD2SAAU	1	< 0.1%
a0110000009pwYgAAI	1	< 0.1%
a0110000009oTWFAA2	1	< 0.1%
a0110000009qpdiAAA	1	< 0.1%
a0110000009phJYAAY	1	< 0.1%
a0110000009pm05AAA	1	< 0.1%
a0110000009qnR8AAI	1	< 0.1%
Other values (563521)	563521	98.5%

Length

Max length	18
Median length	18
Mean length	17.94085201
Min length	14

appt_required_flag
Boolean

MISSING

Distinct count	1
Unique (%)	< 0.1%
Missing	8457
Missing (%)	1.5%
Memory size	4.4 MiB

0	563532
(Missing)	8457

Frequency Table

Value	Count	Frequency (%)
0	563532	98.5%
(Missing)	8457	1.5%

address_external_id
Categorical

HIGH CARDINALITY

Distinct count	563531
Unique (%)	98.5%
Missing	0
Missing (%)	0.0%
Memory size	4.4 MiB

Not Applicable	8458
H8700803	2
H6502127	1
H2672944	1
H2401680	1
Other values (563526)	563526

Value	Count	Frequency (%)
Not Applicable	8458	1.5%
H8700803	2	< 0.1%
H6502127	1	< 0.1%
H2672944	1	< 0.1%
H2401680	1	< 0.1%
H3693818	1	< 0.1%
H6572526	1	< 0.1%
H8179345	1	< 0.1%
H5510278	1	< 0.1%
H0199697	1	< 0.1%
Other values (563521)	563521	98.5%

Length

Max length	14
Median length	8
Mean length	8.085802349
Min length	4

address_phone
Categorical

HIGH CARDINALITY
MISSING
UNIFORM

Distinct count	478111
Unique (%)	85.5%
Missing	12825
Missing (%)	2.2%
Memory size	4.4 MiB

0	58
092-641-1151	26
011-716-2111	26
00-0000-0000	25
03-3813-6111	24
Other values (478106)	559005

Value	Count	Frequency (%)
0	58	< 0.1%
092-641-1151	26	< 0.1%
011-716-2111	26	< 0.1%
00-0000-0000	25	< 0.1%
03-3813-6111	24	< 0.1%
019-651-5111	22	< 0.1%
03-3353-8111	22	< 0.1%
025-223-6161	21	< 0.1%
03-3434-7681	20	< 0.1%
06-6877-5111	20	< 0.1%
Other values (478101)	558900	97.7%
(Missing)	12825	2.2%

Length

Max length	15
Median length	12
Mean length	11.79685973
Min length	1

address_fax
Categorical

MISSING

Distinct count	1
Unique (%)	100.0%
Missing	571988
Missing (%)	> 99.9%
Memory size	4.4 MiB

Not Applicable	1

Value	Count	Frequency (%)
Not Applicable	1	< 0.1%
(Missing)	571988	> 99.9%

Length

Max length	14
Median length	3
Mean length	3.000019231
Min length	3

primary_flag
Boolean

MISSING

Distinct count	2
Unique (%)	< 0.1%
Missing	8457
Missing (%)	1.5%
Memory size	4.4 MiB

1	563531
0	1
(Missing)	8457

Frequency Table

Value	Count	Frequency (%)
1	563531	98.5%
0	1	< 0.1%
(Missing)	8457	1.5%

jp_prefecture_code
Categorical

HIGH CORRELATION
MISSING

Distinct count	49
Unique (%)	< 0.1%
Missing	8895
Missing (%)	1.6%
Memory size	4.4 MiB

13	71726
27	42945
14	34563
23	28739
40	25662
Other values (44)	359459

Value	Count	Frequency (%)
13	71726	12.5%
27	42945	7.5%
14	34563	6.0%
23	28739	5.0%
40	25662	4.5%
11	24932	4.4%
28	24320	4.3%
01	23786	4.2%
12	21375	3.7%
22	15149	2.6%
Other values (39)	249897	43.7%

Length

Max length	14
Median length	2
Mean length	2.015571978
Min length	2

jp_local_area_code
Categorical

HIGH CARDINALITY
MISSING

Distinct count	355
Unique (%)	0.1%
Missing	8949
Missing (%)	1.6%
Memory size	4.4 MiB

201	65123
202	33042
203	28903
204	20940
101	19264
Other values (350)	395768

Value	Count	Frequency (%)
201	65123	11.4%
202	33042	5.8%
203	28903	5.1%
204	20940	3.7%
101	19264	3.4%
205	16574	2.9%
207	15756	2.8%
103	14312	2.5%
206	13643	2.4%
102	13076	2.3%
Other values (345)	322407	56.4%

Length

Max length	14
Median length	3
Mean length	3.000019231
Min length	3

jp_city_code
Categorical

HIGH CARDINALITY
MISSING

Distinct count	1368
Unique (%)	0.2%
Missing	8853
Missing (%)	1.5%
Memory size	4.4 MiB

361400	4229
362200	3889
361100	3389
360500	3294
870100	3248
Other values (1363)	545087

Value	Count	Frequency (%)
361400	4229	0.7%
362200	3889	0.7%
361100	3389	0.6%
360500	3294	0.6%
870100	3248	0.6%
361600	3067	0.5%
361700	2948	0.5%
362000	2856	0.5%
361000	2626	0.5%
830100	2600	0.5%
Other values (1358)	530990	92.8%
(Missing)	8853	1.5%

Length

Max length	6
Median length	6
Mean length	5.953560296
Min length	2

jp_redai_prefecture_code
Categorical

HIGH CORRELATION
MISSING

Distinct count	22
Unique (%)	17.5%
Missing	571863
Missing (%)	> 99.9%
Memory size	4.4 MiB

99	90
54	6
36	4
64	3
22	2
Other values (17)	21

Value	Count	Frequency (%)
99	90	< 0.1%
54	6	< 0.1%
36	4	< 0.1%
64	3	< 0.1%
22	2	< 0.1%
88	2	< 0.1%
33	2	< 0.1%
34	2	< 0.1%
81	2	< 0.1%
35	1	< 0.1%
Other values (12)	12	< 0.1%
(Missing)	571863	> 99.9%

Length

Max length	14
Median length	3
Mean length	2.999800695
Min length	2

jp_larger_section_code
Categorical

HIGH CARDINALITY
MISSING

Distinct count	851
Unique (%)	0.2%
Missing	9214
Missing (%)	1.6%
Memory size	4.4 MiB

001	14112
005	12660
002	12511
003	12477
007	11582
Other values (846)	499433

Value	Count	Frequency (%)
001	14112	2.5%
005	12660	2.2%
002	12511	2.2%
003	12477	2.2%
007	11582	2.0%
004	11356	2.0%
006	11250	2.0%
008	10306	1.8%
010	9931	1.7%
009	9905	1.7%
Other values (841)	446685	78.1%

Length

Max length	14
Median length	3
Mean length	3.000019231
Min length	3

jp_smaller_section_code
Categorical

HIGH CARDINALITY
MISSING

Distinct count	320
Unique (%)	0.1%
Missing	9261
Missing (%)	1.6%
Memory size	4.4 MiB

000	241952
001	85701
002	74198
003	51772
004	30499
Other values (315)	78606

Value	Count	Frequency (%)
000	241952	42.3%
001	85701	15.0%
002	74198	13.0%
003	51772	9.1%
004	30499	5.3%
005	20116	3.5%
006	11134	1.9%
007	6250	1.1%
008	2911	0.5%
101	2326	0.4%
Other values (310)	35869	6.3%
(Missing)	9261	1.6%

Length

Max length	14
Median length	3
Mean length	3.000019231
Min length	3

jp_address_furigana
Categorical

HIGH CARDINALITY
MISSING

Distinct count	60751
Unique (%)	10.8%
Missing	9727
Missing (%)	1.7%
Memory size	4.4 MiB

NO　ADDRRES　DATA	10938
トウキヨウト　チユウオウク　ギンザ	841
トウキヨウト　シンジユクク　ニシシンジユク	744
トウキヨウト　シンジユクク　シンジユク	501
トウキヨウト　ブンキヨウク　ホンゴウ	500
Other values (60746)	548738

Value	Count	Frequency (%)
NO　ADDRRES　DATA	10938	1.9%
トウキヨウト　チユウオウク　ギンザ	841	0.1%
トウキヨウト　シンジユクク　ニシシンジユク	744	0.1%
トウキヨウト　シンジユクク　シンジユク	501	0.1%
トウキヨウト　ブンキヨウク　ホンゴウ	500	0.1%
トウキヨウト　ミナトク　アカサカ	452	0.1%
フクオカケン　フクオカシ　チユウオウク　テンジン	421	0.1%
アイチケン　ナゴヤシ　ナカク　サカエ	407	0.1%
オオサカフ　オオサカシ　キタク　ウメダ	338	0.1%
トウキヨウト　ミナトク　ミナミアオヤマ	337	0.1%
Other values (60741)	546783	95.6%
(Missing)	9727	1.7%

Length

Max length	34
Median length	19
Mean length	19.91064513
Min length	3

inserted_date
Date

Distinct count	2
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.4 MiB

Minimum	2021-03-22 16:48:51.940386
Maximum	2021-03-22 16:49:05.119017

Histogram

Histogram

updated_date
Date

Distinct count	2
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.4 MiB

Minimum	2021-03-22 16:48:51.940386
Maximum	2021-03-22 16:49:05.119017

Histogram

Histogram

First rows

	hco_key	country_code	hco_source_id	modify_id	modify_dt	hco_business_id	inactive_reason	hco_name	hco_type	hco_type_english_name	sector	phone_number	fax_number	website	territory_name	formatted_name	remarks	beds	jp_hco_category	jp_hco_id	jp_hospital_type	jp_account_furigana	jp_hco_name	jp_hco_name_kana	jp_hco_shortname	jp_hco_shortname_kana	jp_management_large_class	jp_management_small_class	jp_hco_hpgp_class	jp_hco_class	jp_hco_kind_code	jp_hco_kind	jp_psychiatric_ward_nursing_type	jp_related_univ_parent	jp_open_close_business_date	jp_hco_rep_code	jp_hco_rep_kana	jp_hco_rep_kanji	jp_hco_pharmacy_class	hco_dcf_cd	jp_duplicate_hco_code	jp_permitted_beds	jp_psychiatric_ward_number	jp_psychosis_hospital_bed_number	record_type_name	hco_external_id	parent_hco_key	parent_hco_name	address_line_1	address_line_2	suburb_town	city	state	postcode	brick	map	hco_address_source_id	appt_required_flag	address_external_id	address_phone	address_fax	primary_flag	jp_prefecture_code	jp_local_area_code	jp_city_code	jp_redai_prefecture_code	jp_larger_section_code	jp_smaller_section_code	jp_address_furigana	inserted_date	updated_date
0	9e9332b37362bb11f505ac9d80f1ecda	JP	0011000000kSq5VAAS	00510000000br12AAA	2016-05-02 04:04:38	NaN	NaN	アンファ動物病院	NaN	NaN	NaN	079-561-1028	NaN	NaN	NaN	アンファ動物病院	NaN	0	NaN	NaN	GP	アンフア　ドウブツ　ビヨウイン	アンファ動物病院	ｱﾝﾌｱﾄﾞｳﾌﾞﾂﾋﾞﾖｳｲﾝ	アンファ動物病院	ｱﾝﾌｱﾄﾞｳﾌﾞﾂﾋﾞﾖｳｲﾝ	NaN	NaN	GP	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	Z031137	NaN	0	NaN	NaN	Deleted_Hospital_jpkk	HZ031137	9e9332b37362bb11f505ac9d80f1ecda	アンファ動物病院	兵庫県三田市大原	NaN	NaN	三田市	兵庫県	669-1515	NaN	<a href="http://maps.google.com/maps?f=q&hl=en&q=兵庫県三田市大原+三田市" target="_blank">map</a>	a011000000JcOQaAAN	0.0	HZ031137	079-561-1028	NaN	1.0	28	219	552100	NaN	010	000	ヒヨウゴケン　サンダシ　オオハラ	2021-03-22 16:48:51.940386	2021-03-22 16:48:51.940386
1	a40fb2f707dfe9fd1a1aef8653feb5ae	JP	0011000000q6P6SAAU	00510000000br12AAA	2014-08-09 06:17:32	NaN	NaN	スズケン沼津	NaN	NaN	NaN	NaN	NaN	NaN	NaN	スズケン沼津	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	Dummy_CCHospital_jpkk	Not Applicable	a40fb2f707dfe9fd1a1aef8653feb5ae	スズケン沼津	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	Not Applicable	NaN	Not Applicable	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2021-03-22 16:48:51.940386	2021-03-22 16:48:51.940386
2	fec6bd13bcca93d4916bb5ed83e901d6	JP	0011000000j3ScNAAU	00510000000br12AAA	2014-02-21 05:07:56	NaN	NaN	千葉県薬務課	NaN	NaN	NaN	NaN	NaN	NaN	NaN	千葉県薬務課	NaN	NaN	NaN	NaN	NaN	NaN	千葉県薬務課	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	Dummy_CCHospital_jpkk	Not Applicable	fec6bd13bcca93d4916bb5ed83e901d6	千葉県薬務課	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	Not Applicable	NaN	Not Applicable	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2021-03-22 16:48:51.940386	2021-03-22 16:48:51.940386
3	0c485e5c390b438685277a60d9f8efe1	JP	0011000000q64ssAAA	00510000000br12AAA	2014-08-06 13:32:52	NaN	NaN	スミダ病院	NaN	NaN	NaN	NaN	NaN	NaN	NaN	スミダ病院	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	Dummy_CCHospital_jpkk	Not Applicable	0c485e5c390b438685277a60d9f8efe1	スミダ病院	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	Not Applicable	NaN	Not Applicable	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2021-03-22 16:48:51.940386	2021-03-22 16:48:51.940386
4	541744561ebd2812d4c09dc70d821b35	JP	0011000000q6P70AAE	00510000000br12AAA	2014-08-09 06:17:33	NaN	NaN	コトブキ薬局（大道ＨＰ）	NaN	NaN	NaN	NaN	NaN	NaN	NaN	コトブキ薬局（大道ＨＰ）	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	Dummy_CCHospital_jpkk	Not Applicable	541744561ebd2812d4c09dc70d821b35	コトブキ薬局（大道ＨＰ）	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	Not Applicable	NaN	Not Applicable	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2021-03-22 16:48:51.940386	2021-03-22 16:48:51.940386
5	5ffceca1ce3571f7a374f0b1a4374fff	JP	0011000000q64upAAA	00510000000br12AAA	2014-08-06 13:32:55	NaN	NaN	タガワチョウリツ病院（？）	NaN	NaN	NaN	NaN	NaN	NaN	NaN	タガワチョウリツ病院（？）	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	Dummy_CCHospital_jpkk	Not Applicable	5ffceca1ce3571f7a374f0b1a4374fff	タガワチョウリツ病院（？）	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	Not Applicable	NaN	Not Applicable	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2021-03-22 16:48:51.940386	2021-03-22 16:48:51.940386
6	8385f8b15147c0ed7ffc8b1adfbe12ee	JP	0011000000UgqaTAAR	00510000000br12AAA	2016-05-02 04:04:08	NaN	NaN	前田動物病院	NaN	NaN	NaN	0573-68-3600	NaN	NaN	NaN	前田動物病院	NaN	0	NaN	NaN	GP	マエダ　ドウブツビヨウイン	前田動物病院	ﾏｴﾀﾞﾄﾞｳﾌﾞﾂﾋﾞﾖｳｲﾝ	前田動物病院	ﾏｴﾀﾞﾄﾞｳﾌﾞﾂﾋﾞﾖｳｲﾝ	NaN	NaN	GP	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	Z018414	NaN	0	NaN	NaN	Deleted_Hospital_jpkk	HZ018414	8385f8b15147c0ed7ffc8b1adfbe12ee	前田動物病院	岐阜県中津川市茄子川	NaN	NaN	中津川市	岐阜県	509-9132	NaN	<a href="http://maps.google.com/maps?f=q&hl=en&q=岐阜県中津川市茄子川+中津川市" target="_blank">map</a>	a0110000009ph4uAAA	0.0	HZ018414	0573-68-3600	NaN	1.0	21	206	470900	NaN	022	000	ギフケン　ナカツガワシ　ナスビガワ	2021-03-22 16:48:51.940386	2021-03-22 16:48:51.940386
7	56b81f66057fd244936d856b65dbc63a	JP	0011000000UgAoZAAV	00510000000br12AAA	2016-05-02 04:04:31	NaN	NaN	串田動物病院	NaN	NaN	NaN	NaN	NaN	NaN	NaN	串田動物病院	NaN	0	NaN	NaN	GP	クシダドウブツビヨウイン	串田動物病院	ｸｼﾀﾞﾄﾞｳﾌﾞﾂﾋﾞﾖｳｲﾝ	串田動物病院	ｸｼﾀﾞﾄﾞｳﾌﾞﾂﾋﾞﾖｳｲﾝ	NaN	NaN	GP	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	Z000621	NaN	0	NaN	NaN	Deleted_Hospital_jpkk	HZ000621	56b81f66057fd244936d856b65dbc63a	串田動物病院	京都府京都市西京区	NaN	NaN	京都市西京区	京都府	615-8085	NaN	<a href="http://maps.google.com/maps?f=q&hl=en&q=京都府京都市西京区+京都市西京区" target="_blank">map</a>	a0110000009p8tZAAQ	0.0	HZ000621	NaN	NaN	1.0	26	111	531000	NaN	000	000	キヨウトフ　キヨウトシ　ニシキヨウク	2021-03-22 16:48:51.940386	2021-03-22 16:48:51.940386
8	9d8e06f5af86d56ef829ed37953924e8	JP	0011000000uNGusAAG	00510000000br12AAA	2016-05-02 04:04:38	NaN	NaN	㈲さわもと犬猫病院　麻薬	NaN	NaN	NaN	095-881-1012	NaN	NaN	NaN	㈲さわもと犬猫病院　麻薬	NaN	0	NaN	NaN	GP	ユ)サワモトイヌネコビヨウインマヤク	㈲さわもと犬猫病院　麻薬	ﾕ)ｻﾜﾓﾄｲﾇﾈｺﾋﾞﾖｳｲﾝﾏﾔｸ	㈲さわもと犬猫病院　麻薬	ﾕ)ｻﾜﾓﾄｲﾇﾈｺﾋﾞﾖｳｲﾝﾏﾔｸ	NaN	NaN	GP	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	Z031797	NaN	0	NaN	NaN	Deleted_Hospital_jpkk	HZ031797	9d8e06f5af86d56ef829ed37953924e8	㈲さわもと犬猫病院　麻薬	長崎県西彼杵郡時津町浜田郷	NaN	NaN	西彼杵郡	長崎県	851-2102	NaN	<a href="http://maps.google.com/maps?f=q&hl=en&q=長崎県西彼杵郡時津町浜田郷+西彼杵郡" target="_blank">map</a>	a011000000Sga04AAB	0.0	HZ031797	095-881-1012	NaN	1.0	42	308	837500	NaN	007	000	ナガサキケン　ニシソノギグン　トギツチヨウ　ハマダゴウ	2021-03-22 16:48:51.940386	2021-03-22 16:48:51.940386
9	3331cf549901b60d2baaca446f46c74f	JP	0011000000q6PEBAA2	00510000000br12AAA	2014-08-09 06:17:42	NaN	NaN	株式会社エバルス高梁支店	NaN	NaN	NaN	NaN	NaN	NaN	NaN	株式会社エバルス高梁支店	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	Dummy_CCHospital_jpkk	Not Applicable	3331cf549901b60d2baaca446f46c74f	株式会社エバルス高梁支店	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	Not Applicable	NaN	Not Applicable	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2021-03-22 16:48:51.940386	2021-03-22 16:48:51.940386

Last rows

	hco_key	country_code	hco_source_id	modify_id	modify_dt	hco_business_id	inactive_reason	hco_name	hco_type	hco_type_english_name	sector	phone_number	fax_number	website	territory_name	formatted_name	remarks	beds	jp_hco_category	jp_hco_id	jp_hospital_type	jp_account_furigana	jp_hco_name	jp_hco_name_kana	jp_hco_shortname	jp_hco_shortname_kana	jp_management_large_class	jp_management_small_class	jp_hco_hpgp_class	jp_hco_class	jp_hco_kind_code	jp_hco_kind	jp_psychiatric_ward_nursing_type	jp_related_univ_parent	jp_open_close_business_date	jp_hco_rep_code	jp_hco_rep_kana	jp_hco_rep_kanji	jp_hco_pharmacy_class	hco_dcf_cd	jp_duplicate_hco_code	jp_permitted_beds	jp_psychiatric_ward_number	jp_psychosis_hospital_bed_number	record_type_name	hco_external_id	parent_hco_key	parent_hco_name	address_line_1	address_line_2	suburb_town	city	state	postcode	brick	map	hco_address_source_id	address_external_id	address_phone	address_fax	primary_flag	jp_prefecture_code	jp_local_area_code	jp_city_code	jp_redai_prefecture_code	jp_larger_section_code	jp_smaller_section_code	jp_address_furigana	inserted_date	updated_date
571979	f4e5f71d2185e6bad9727300e38c082e	JP	0011000000UfpiDAAR	00510000000br12AAA	2021-01-30 16:34:56	7200591	NaN	阪本病院　医療	アルトマーク施設	NaN	NaN	0879-25-1121	NaN	NaN	NaN	阪本病院　医療	NaN	52	アルトマーク施設	7200591	GP	サカモトビヨウイン　イリヨウ	医療法人社団聖心会阪本病院	ｲﾘﾖｳﾎｳｼﾞﾝｼﾔﾀﾞﾝｾｲｼﾝｶｲｻｶﾓﾄﾋﾞﾖｳｲﾝ	阪本病院　医療	ｻｶﾓﾄﾋﾞﾖｳｲﾝｲﾘﾖｳ	その他	医療	GP	病院（大学ＨＰ以外）	1	一般	NaN	NaN	NaN	246843	ｵｶﾞﾜﾄﾓﾔ	小川　智也	病院	7200591	NaN	52	NaN	NaN	Hospital	H7200591	f4e5f71d2185e6bad9727300e38c082e	阪本病院　医療	香川県東かがわ市川東	NaN	NaN	東かがわ市	香川県	769-2602	NaN	<a href="http://maps.google.com/maps?f=q&hl=en&q=香川県東かがわ市川東+東かがわ市" target="_blank">map</a>	a0110000009osXBAAY	H7200591	0879-25-1121	NaN	1.0	37	207	720700	NaN	008	000	カガワケン　ヒガシカガワシ　カワヒガシ	2021-03-22 16:48:51.940386	2021-03-22 16:48:51.940386
571980	8b8a0d6613a72c32f1478a861c1828ad	JP	0011000000UgMucAAF	00510000000br12AAA	2021-02-16 03:56:13	3271604	NaN	マツモトキヨシアピタ宇都宮店	アルトマーク施設	NaN	NaN	028-645-7500	NaN	NaN	NaN	マツモトキヨシアピタ宇都宮店	NaN	NaN	アルトマーク施設	3271604	GP	マツモトキヨシアピタウツノミヤテン	㈱マツモトキヨシ東日本販売・薬マツモトキヨシアピタ宇都宮店	ﾏﾂﾓﾄｷﾖｼﾋｶﾞｼﾆﾎﾝﾊﾝﾊﾞｲ.ｸｽﾘﾏﾂﾓﾄｷﾖｼｱﾋﾟﾀｳﾂﾉﾐﾔﾃﾝ	マツモトキヨシアピタ宇都宮店	ﾏﾂﾓﾄｷﾖｼｱﾋﾟﾀｳﾂﾉﾐﾔﾃﾝ	その他	会社	GP	店舗販売業（Ｂ）（旧薬種商販売業）	NaN	NaN	NaN	NaN	NaN	NaN	ﾀｶﾉｼﾖｳｼﾞ	高野　昌司	薬局薬店	3271604	NaN	NaN	NaN	NaN	Pharmacy	H3271604	8b8a0d6613a72c32f1478a861c1828ad	マツモトキヨシアピタ宇都宮店	栃木県宇都宮市江曽島本町	NaN	NaN	宇都宮市	栃木県	321-0101	NaN	<a href="http://maps.google.com/maps?f=q&hl=en&q=栃木県宇都宮市江曽島本町+宇都宮市" target="_blank">map</a>	a0110000009pIxuAAE	H3271604	028-645-7500	NaN	1.0	09	201	320100	NaN	024	000	トチギケン　ウツノミヤシ　エソジマホンチヨウ	2021-03-22 16:48:51.940386	2021-03-22 16:48:51.940386
571981	50ca161647947244f3280b121c11793f	JP	0015F00001GWAFuQAP	00510000000br12AAA	2021-02-24 17:02:24	3782132	NaN	秦野調剤薬局	アルトマーク施設	NaN	NaN	0463-84-7906	NaN	NaN	NaN	秦野調剤薬局	NaN	NaN	アルトマーク施設	3782132	GP	ハダノチヨウザイヤツキヨク	㈱慶陽秦野調剤薬局	ｹｲﾖｳﾊﾀﾞﾉﾁﾖｳｻﾞｲﾔﾂｷﾖｸ	秦野調剤薬局	ﾊﾀﾞﾉﾁﾖｳｻﾞｲﾔﾂｷﾖｸ	その他	会社	GP	調剤薬局	NaN	NaN	NaN	NaN	NaN	NaN	ｵｵﾉﾐｷ	大野　未希	薬局薬店	3782132	3782640	NaN	NaN	NaN	Deleted_Pharmacy_jpkk	H3782132	50ca161647947244f3280b121c11793f	秦野調剤薬局	神奈川県秦野市寿町	NaN	NaN	秦野市	神奈川県	257-0042	NaN	<a href="http://maps.google.com/maps?f=q&hl=en&q=神奈川県秦野市寿町+秦野市" target="_blank">map</a>	a015F00000tFnquQAC	H3782132	0463-84-7906	NaN	1.0	14	211	372800	NaN	011	000	カナガワケン　ハダノシ　コトブキチヨウ	2021-03-22 16:48:51.940386	2021-03-22 16:48:51.940386
571982	6aca95149f82ae883ef071bb9eb7e4f9	JP	0011000000UgXPhAAN	00510000000br12AAA	2021-03-07 18:40:51	8472152	NaN	ドラッグイレブン清水バイパス店	アルトマーク施設	NaN	NaN	096-341-6355	NaN	NaN	NaN	ドラッグイレブン清水バイパス店	NaN	NaN	アルトマーク施設	8472152	GP	ドラツグイレブンシミズバイパステン	ＪＲ九州ドラッグイレブン㈱ドラッグイレブン清水バイパス店	JRｷﾕｳｼﾕｳﾄﾞﾗﾂｸﾞｲﾚﾌﾞﾝﾄﾞﾗﾂｸﾞｲﾚﾌﾞﾝｼﾐｽﾞﾊﾞｲﾊﾟｽﾃﾝ	ドラッグイレブン清水バイパス店	ﾄﾞﾗﾂｸﾞｲﾚﾌﾞﾝｼﾐｽﾞﾊﾞｲﾊﾟｽﾃﾝ	その他	会社	GP	店舗販売業（Ｂ）（旧薬種商販売業）	NaN	NaN	NaN	NaN	NaN	NaN	ﾊﾀｲｼﾝｼﾞ	畑井　慎司	薬局薬店	8472152	NaN	NaN	NaN	NaN	Pharmacy	H8472152	6aca95149f82ae883ef071bb9eb7e4f9	ドラッグイレブン清水バイパス店	熊本県熊本市北区高平	NaN	NaN	熊本市北区	熊本県	860-0085	NaN	<a href="http://maps.google.com/maps?f=q&hl=en&q=熊本県熊本市北区高平+熊本市北区" target="_blank">map</a>	a0110000009pRxkAAE	H8472152	096-341-6355	NaN	1.0	43	105	840160	NaN	073	003	クマモトケン　クマモトシ　キタク　タカヒラ	2021-03-22 16:48:51.940386	2021-03-22 16:48:51.940386
571983	561219c4dd6e504e5ccb58daaf0bbeff	JP	0015F00001GW4O4QAL	00510000000br12AAA	2021-03-14 16:31:59	3479640	NaN	ドラッグセイムス新座中央通り店	アルトマーク施設	NaN	NaN	048-480-2100	NaN	NaN	NaN	ドラッグセイムス新座中央通り店	NaN	NaN	アルトマーク施設	3479640	GP	ドラツグセイムスニイザチユウオウドオリテン	㈱富士薬品ドラッグセイムス新座中央通り店	ﾌｼﾞﾔｸﾋﾝﾄﾞﾗﾂｸﾞｾｲﾑｽﾆｲｻﾞﾁﾕｳｵｳﾄﾞｵﾘﾃﾝ	ドラッグセイムス新座中央通り店	ﾄﾞﾗﾂｸﾞｾｲﾑｽﾆｲｻﾞﾁﾕｳｵｳﾄﾞｵﾘﾃﾝ	その他	会社	GP	店舗販売業（Ｂ）（旧薬種商販売業）	NaN	NaN	NaN	NaN	NaN	NaN	ﾀｶﾔﾅｷﾞﾏｻﾕｷ	高柳　昌幸	薬局薬店	3479640	NaN	NaN	NaN	NaN	Pharmacy	H3479640	561219c4dd6e504e5ccb58daaf0bbeff	ドラッグセイムス新座中央通り店	埼玉県新座市東	NaN	NaN	新座市	埼玉県	352-0002	NaN	<a href="http://maps.google.com/maps?f=q&hl=en&q=埼玉県新座市東+新座市" target="_blank">map</a>	a015F00000tFB9mQAG	H3479640	048-480-2100	NaN	1.0	11	230	343000	NaN	021	001	サイタマケン　ニイザシ　ヒガシ	2021-03-22 16:48:51.940386	2021-03-22 16:48:51.940386
571984	b1620705937d0b98b5c6b5c3c1df831f	JP	0011000000Uh60PAAR	00510000000br12AAA	2021-02-16 03:57:31	3779326	NaN	そうごう薬局今宿店	アルトマーク施設	NaN	NaN	045-951-1481	NaN	NaN	NaN	そうごう薬局今宿店	NaN	NaN	アルトマーク施設	3779326	GP	ソウゴウヤツキヨクイマジユクテン	総合メディカル㈱そうごう薬局今宿店	ｿｳｺﾞｳﾒﾃﾞｲｶﾙｿｳｺﾞｳﾔﾂｷﾖｸｲﾏｼﾞﾕｸﾃﾝ	そうごう薬局今宿店	ｿｳｺﾞｳﾔﾂｷﾖｸｲﾏｼﾞﾕｸﾃﾝ	その他	会社	GP	調剤薬局	NaN	NaN	NaN	NaN	NaN	NaN	ｻｶﾓﾄｹﾝｼﾞ	坂本　賢治	薬局薬店	3779326	NaN	NaN	NaN	NaN	Pharmacy	H3779326	b1620705937d0b98b5c6b5c3c1df831f	そうごう薬局今宿店	神奈川県横浜市旭区今宿西町	NaN	NaN	横浜市旭区	神奈川県	241-0031	NaN	<a href="http://maps.google.com/maps?f=q&hl=en&q=神奈川県横浜市旭区今宿西町+横浜市旭区" target="_blank">map</a>	a0110000009pu0xAAA	H3779326	045-951-1481	NaN	1.0	14	112	371100	NaN	003	000	カナガワケン　ヨコハマシ　アサヒク　イマジユクニシチヨウ	2021-03-22 16:48:51.940386	2021-03-22 16:48:51.940386
571985	455f8386f730a8e3955ccfa53ca99bb3	JP	0015F00001PAqEgQAL	00510000000br12AAA	2021-02-20 20:36:35	3782655	NaN	ウェルパーク川崎中野島５丁目店	アルトマーク施設	NaN	NaN	044-322-0113	NaN	NaN	NaN	ウェルパーク川崎中野島５丁目店	NaN	NaN	アルトマーク施設	3782655	GP	ウエルパ-クカワサキナカノシマゴチヨウメテン	㈱ウェルパーク川崎中野島５丁目店	ｳｴﾙﾊﾟ-ｸｶﾜｻｷﾅｶﾉｼﾏｺﾞﾁﾖｳﾒﾃﾝ	ウェルパーク川崎中野島５丁目店	ｳｴﾙﾊﾟ-ｸｶﾜｻｷﾅｶﾉｼﾏｺﾞﾁﾖｳﾒﾃﾝ	その他	会社	GP	店舗販売業（Ｂ）（旧薬種商販売業）	NaN	NaN	NaN	NaN	NaN	NaN	ｼﾏﾓﾄｶｽﾞﾋｺ	島本　和彦	薬局薬店	3782655	NaN	NaN	NaN	NaN	Pharmacy	H3782655	455f8386f730a8e3955ccfa53ca99bb3	ウェルパーク川崎中野島５丁目店	神奈川県川崎市多摩区中野島	NaN	NaN	川崎市多摩区	神奈川県	214-0012	NaN	<a href="http://maps.google.com/maps?f=q&hl=en&q=神奈川県川崎市多摩区中野島+川崎市多摩区" target="_blank">map</a>	a015F000015jiAhQAI	H3782655	044-322-0113	NaN	1.0	14	135	375300	NaN	025	005	カナガワケン　カワサキシ　タマク　ナカノシマ	2021-03-22 16:48:51.940386	2021-03-22 16:48:51.940386
571986	f9af984abd3ee2e03d941b674e29bd31	JP	0015F00001NyMvEQAV	00510000000br12AAA	2021-03-20 16:38:07	1179962	NaN	ツルハドラッグ様似店	アルトマーク施設	NaN	NaN	0146-39-2680	NaN	NaN	NaN	ツルハドラッグ様似店	NaN	NaN	アルトマーク施設	1179962	GP	ツルハドラツグサマニテン	㈱ツルハツルハドラッグ様似店	ﾂﾙﾊﾂﾙﾊﾄﾞﾗﾂｸﾞｻﾏﾆﾃﾝ	ツルハドラッグ様似店	ﾂﾙﾊﾄﾞﾗﾂｸﾞｻﾏﾆﾃﾝ	その他	会社	GP	店舗販売業（Ｂ）（旧薬種商販売業）	NaN	NaN	NaN	NaN	NaN	NaN	ﾔﾊﾀﾏｻﾋﾛ	八幡　政浩	薬局薬店	1179962	NaN	NaN	NaN	NaN	Pharmacy	H1179962	f9af984abd3ee2e03d941b674e29bd31	ツルハドラッグ様似店	北海道様似郡様似町大通	NaN	NaN	様似郡	北海道	058-0014	NaN	<a href="http://maps.google.com/maps?f=q&hl=en&q=北海道様似郡様似町大通+様似郡" target="_blank">map</a>	a015F000013wXqWQAU	H1179962	0146-39-2680	NaN	1.0	01	608	117912	NaN	005	001	ホツカイドウ　サマニグン　サマニチヨウ　オオドオリ	2021-03-22 16:48:51.940386	2021-03-22 16:48:51.940386
571987	f4ace385acaec74aeb9f90eff0dd9127	JP	0015F00001J7H4vQAF	00510000000br12AAA	2021-03-20 16:38:34	5578993	NaN	スギ薬局宝塚小林店	アルトマーク施設	NaN	NaN	0797-61-8891	NaN	NaN	NaN	スギ薬局宝塚小林店	NaN	NaN	アルトマーク施設	5578993	GP	スギヤツキヨクタカラヅカオバヤシテン	㈱スギ薬局宝塚小林店	ｽｷﾞﾔﾂｷﾖｸﾀｶﾗﾂﾞｶｵﾊﾞﾔｼﾃﾝ	スギ薬局宝塚小林店	ｽｷﾞﾔﾂｷﾖｸﾀｶﾗﾂﾞｶｵﾊﾞﾔｼﾃﾝ	その他	会社	GP	調剤薬局	NaN	NaN	NaN	NaN	NaN	NaN	ｽｷﾞｳﾗｶﾂﾉﾘ	杉浦　克典	薬局薬店	5578993	NaN	NaN	NaN	NaN	Pharmacy	H5578993	f4ace385acaec74aeb9f90eff0dd9127	スギ薬局宝塚小林店	兵庫県宝塚市小林	NaN	NaN	宝塚市	兵庫県	665-0034	NaN	<a href="http://maps.google.com/maps?f=q&hl=en&q=兵庫県宝塚市小林+宝塚市" target="_blank">map</a>	a015F00000yACouQAG	H5578993	0797-61-8891	NaN	1.0	28	214	552400	NaN	017	003	ヒヨウゴケン　タカラヅカシ　オバヤシ	2021-03-22 16:48:51.940386	2021-03-22 16:48:51.940386
571988	1912489b6077f79f201a7ef6d56ab540	JP	0015F000016qduVQAQ	00510000000br12AAA	2021-03-20 16:36:52	4773492	NaN	スギドラッグ可児広見店	アルトマーク施設	NaN	NaN	0574-48-8302	NaN	NaN	NaN	スギドラッグ可児広見店	NaN	NaN	アルトマーク施設	4773492	GP	スギドラツグカニヒロミテン	㈱スギ薬局スギドラッグ可児広見店	ｽｷﾞﾔﾂｷﾖｸｽｷﾞﾄﾞﾗﾂｸﾞｶﾆﾋﾛﾐﾃﾝ	スギドラッグ可児広見店	ｽｷﾞﾄﾞﾗﾂｸﾞｶﾆﾋﾛﾐﾃﾝ	その他	会社	GP	店舗販売業（Ｂ）（旧薬種商販売業）	NaN	NaN	NaN	NaN	NaN	NaN	ｽｷﾞｳﾗｶﾂﾉﾘ	杉浦　克典	薬局薬店	4773492	NaN	NaN	NaN	NaN	Pharmacy	H4773492	1912489b6077f79f201a7ef6d56ab540	スギドラッグ可児広見店	岐阜県可児市広見	NaN	NaN	可児市	岐阜県	509-0214	NaN	<a href="http://maps.google.com/maps?f=q&hl=en&q=岐阜県可児市広見+可児市" target="_blank">map</a>	a015F00000iQAW9QAO	H4773492	0574-48-8302	NaN	1.0	21	214	471400	NaN	030	000	ギフケン　カニシ　ヒロミ	2021-03-22 16:48:51.940386	2021-03-22 16:48:51.940386

Overview

Variables

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows